﻿CREATE TABLE [dbo].[FieldTypes] (
    [FieldTypeKey]          UNIQUEIDENTIFIER NOT NULL,
    [Name]                  NVARCHAR (50)    NOT NULL,
    [ListEnum]              NVARCHAR (50)    NOT NULL,
    [RequiredErrorTemplate] NVARCHAR (255)   NULL,
    [RegEx]                 NVARCHAR (255)   NULL,
    [RegExError]            NVARCHAR (255)   NULL,
    [SortOrder]             SMALLINT         NOT NULL,
    [CreatedOn]             DATETIME2 (7)    NOT NULL
);

